                           RELEASES\FAB\POS7111/07/05                           

A_PAY.DBF

    OUTLET      C   3  0
    STATION     C   2  0
    REF_NUM     C   5  0
    SUB_REF     C   2  0
    INDEX       C   3  0
    TRAN_TYPE   C   1  0
    STAFF       C   7  0
    SEAT        C   1  0
    PAY_TYPE    C   4  0
    INPUT_TYPE  C   1  0
    TIME        C   5  0
    BILL_AMT    N  10  2
    QTY         N   3  0
    AMOUNT      N  10  2
    CURRENCY    C   3  0
    EX_RATE     N   7  3
    NET_AMOUNT  N  10  2
    TIPS        N  10  2
    SERVICE     N  10  2
    OVER_AMT    N  10  2
    ROOM        C  10  0
    CARD_NO     C  18  0
    CUST_NAME   C  20  0
    EXP_DATE    C   5  0
    APP_NO      C  12  0
    TROUTD      C  10  0
    SHIFT       N   1  0
    COVERS      N   4  0
    TAX_REF     C   5  0
    RD          C  20  0
    VOID_INDEX  C   3  0
    REMARKS     C  10  0

    A_PAY.CDX
    REF_TAG    --> REF_NUM+SUB_REF+INDEX

A_PAYCAT.DBF

    REF_NUM     C   5  0
    SUB_REF     C   2  0
    INDEX       C   3  0
    CATCODE     C   3  0
    CAT_AMT     N  10  2
    DISC_AMT    N  10  2
    TAX_AMT     N  10  2

    A_PAYCAT.CDX
    REF_TAG    --> REF_NUM+SUB_REF+INDEX

A_REF.DBF

    REF         N   4  0
    CODE        N  10  0

A_TRAN.DBF

    REF_NUM     C   5  0
    SUB_REF     C   2  0
    STATION_ID  C   2  0
    OUTLET      C   3  0
    TABLE_NUM   C   5  0
    TRAN_TYPE   C   1  0
    OPEN_STAFF  C   7  0
    BILL_STAFF  C   7  0
    PAY_STAFF   C   7  0
    SERV_STAFF  C   7  0
    PERSON      N   4  0
    IN_DATE     D   8  0
    IN_TIME     C   5  0
    BILL_DATE   D   8  0
    BILL_TIME   C   5  0
    HEAD_COUNT  N   4  0
    ORDER_AMT   N  10  2
    ITEM_DISC   N  10  2
    CAT_DISC    N  10  2
    ROOM_AMT    N  10  2
    ROOM_DISC   N  10  2
    HEAD_AMT    N  10  2
    HEAD_DISC   N  10  2
    SERV_AMT    N  10  2
    TAX_AMT     N  10  2
    TAX_AMT_1   N  10  2
    ORDER_DISC  N  10  2
    ROUNDING    N   5  2
    BILL_AMT    N  10  2
    CASH_AMT    N  10  2
    OTHER_AMT   N  10  2
    NSALES_AMT  N  10  2
    OVER_AMT    N  10  2
    TIPS        N   8  2
    MEMBER      N   1  0
    PAY_COUNT   N   3  0
    VOID_REF    C   7  0
    REASON      C   2  0
    INDEX       C   5  0
    PERIOD      C   1  0
    RECEIPT     L   1  0
    PRT_COUNT   N   1  0
    PAYTYPE_1   C   4  0
    PAYTYPE_2   C   4  0
    PAYTYPE_3   L   1  0
    SETTLED     L   1  0
    REMARKS     C  10  0

IUSAGE.DBF

    CODE        C   4  0
    DATETIME    C  12  0
    UNIT_COST   N   9  3
    QTY         N   8  2
    COST        N  13  3

    IUSAGE.CDX
    CODE_TAG   --> CODE

LOANDROP.DBF

    OUTLET      C   3  0
    STATION     C   2  0
    TYPE        C   1  0
    REASON      C   2  0
    DATE        D   8  0
    TIME        C   5  0
    STAFF       C   7  0
    AMOUNT      N  10  2
    PERIOD      N   1  0

REF.DBF

    NEW_REF     C   5  0
    ORDER_REF   C   5  0
    TRAN_INDEX  C   5  0
    MID_COUNT   C   4  0
    DAY_COUNT   C   4  0

T_ATT.DBF

    OUTLET      C   3  0
    ITEM_IDX    C   5  0
    ATT_IDX     C   2  0
    ATT_GROUP   C   2  0
    ATT_CODE    C   2  0
    CHANGE_AMT  N  10  2

    T_ATT.CDX
    IDX_TAG    --> ITEM_IDX+ATT_IDX

T_LOG.DBF

    OUTLET      C   3  0
    DATE        D   8  0
    TIME        C   8  0
    STAFF       C   7  0
    LOG_TYPE    C   4  0
    TYPE        C   1  0
    INDEX       C   5  0
    REF_NUM     C   5  0
    SUB_REF     C   2  0
    TABLE1      C   5  0
    TABLE2      C   5  0
    QTY1        N   5  0
    QTY2        N   5  0
    QTY3        N   5  0
    AMT1        N  10  2
    AMT2        N  10  2
    AMT3        N  10  2
    REMARK1     C  10  0
    REMARK2     C  10  0
    REMARK3     C  10  0
    REMARK4     C  40  0

    T_LOG.CDX
    REF_TAG    --> REF_NUM+SUB_REF
    REM1_TAG   --> REMARK1
    REM2_TAG   --> REMARK2
    STF_TAG    --> STAFF
    TYPE_TAG   --> LOG_TYPE

T_ORDER.DBF

    OUTLET      C   3  0
    REF_NUM     C   5  0
    SUB_REF     C   2  0
    TYPE        C   1  0
    TABLE_NUM   C   5  0
    ITEM_CODE   C   4  0
    ITEM_IDX    C   5  0
    SETMEAL     N   3  0
    SEAT        C   1  0
    SERVICE     L   1  0
    DATE        D   8  0
    TIME        C   5  0
    STAFF       C   7  0
    PRICE_TYPE  C   1  0
    QTY         N   5  0
    AMT         N  10  2
    CHG_AMT     N  10  2
    IDISC_TYPE  C   8  0
    IDISC_QTY   N   5  0
    ITEM_DISC   N  10  2
    CAT_DISC    N  10  2
    ORDER_DISC  N  10  2
    TAX         N  10  2
    CANCEL      N   5  0
    FREE        N   5  0
    COST        N  10  2
    KIC_MESS    C   2  0
    TA          L   1  0
    REASON      C   2  0
    SEP_CHAR    C   1  0
    PERIOD      C   1  0
    PINDEX      C   5  0
    OINDEX      C   6  0
    KCONFIRM    L   1  0
    REMARKS     C  10  0

    T_ORDER.CDX
    REF_TAG    --> REF_NUM+SUB_REF

T_PAY.DBF

    OUTLET      C   3  0
    STATION     C   2  0
    REF_NUM     C   5  0
    SUB_REF     C   2  0
    INDEX       C   3  0
    TRAN_TYPE   C   1  0
    STAFF       C   7  0
    SEAT        C   1  0
    PAY_TYPE    C   4  0
    INPUT_TYPE  C   1  0
    TIME        C   5  0
    BILL_AMT    N  10  2
    QTY         N   3  0
    AMOUNT      N  10  2
    CURRENCY    C   3  0
    EX_RATE     N   7  3
    NET_AMOUNT  N  10  2
    TIPS        N  10  2
    SERVICE     N  10  2
    OVER_AMT    N  10  2
    ROOM        C  10  0
    CARD_NO     C  18  0
    CUST_NAME   C  20  0
    EXP_DATE    C   5  0
    APP_NO      C  12  0
    TROUTD      C  10  0
    SHIFT       N   1  0
    COVERS      N   4  0
    TAX_REF     C   5  0
    RD          C  20  0
    VOID_INDEX  C   3  0
    REMARKS     C  10  0

    T_PAY.CDX
    REF_TAG    --> REF_NUM+SUB_REF+INDEX

T_PAYCAT.DBF

    REF_NUM     C   5  0
    SUB_REF     C   2  0
    INDEX       C   3  0
    CATCODE     C   3  0
    CAT_AMT     N  10  2
    DISC_AMT    N  10  2
    TAX_AMT     N  10  2

    T_PAYCAT.CDX
    REF_TAG    --> REF_NUM+SUB_REF+INDEX

T_TRAN.DBF

    REF_NUM     C   5  0
    SUB_REF     C   2  0
    STATION_ID  C   2  0
    OUTLET      C   3  0
    TABLE_NUM   C   5  0
    TRAN_TYPE   C   1  0
    OPEN_STAFF  C   7  0
    BILL_STAFF  C   7  0
    PAY_STAFF   C   7  0
    SERV_STAFF  C   7  0
    PERSON      N   4  0
    IN_DATE     D   8  0
    IN_TIME     C   5  0
    BILL_DATE   D   8  0
    BILL_TIME   C   5  0
    HEAD_COUNT  N   4  0
    ORDER_AMT   N  10  2
    ITEM_DISC   N  10  2
    CAT_DISC    N  10  2
    ROOM_AMT    N  10  2
    ROOM_DISC   N  10  2
    HEAD_AMT    N  10  2
    HEAD_DISC   N  10  2
    SERV_AMT    N  10  2
    TAX_AMT     N  10  2
    TAX_AMT_1   N  10  2
    ORDER_DISC  N  10  2
    ROUNDING    N   5  2
    BILL_AMT    N  10  2
    CASH_AMT    N  10  2
    OTHER_AMT   N  10  2
    NSALES_AMT  N  10  2
    OVER_AMT    N  10  2
    TIPS        N   8  2
    MEMBER      N   1  0
    PAY_COUNT   N   3  0
    VOID_REF    C   7  0
    REASON      C   2  0
    INDEX       C   5  0
    PERIOD      C   1  0
    RECEIPT     L   1  0
    PRT_COUNT   N   1  0
    PAYTYPE_1   C   4  0
    PAYTYPE_2   C   4  0
    PAYTYPE_3   L   1  0
    SETTLED     L   1  0
    REMARKS     C  10  0

