VAPS INVOICE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
INV_APPROVAL |
XXX |
VARCHAR2 |
1 |
INV_ATTACHMENT |
XXX |
VARCHAR2 |
1 |
INV_BATCH |
XXX |
VARCHAR2 |
7 |
INV_BATCH_SEQ |
XXX |
VARCHAR2 |
4 |
INV_CANCELLED |
XXX |
VARCHAR2 |
1 |
INV_CHECKNUMBER |
XXX |
VARCHAR2 |
6 |
INV_DATE |
XXX |
DATE |
|
INV_DATE_PAID |
XXX |
VARCHAR2 |
6 |
INV_DATE_SENT_TO_PAY |
XXX |
DATE |
|
INV_DATE_TO_PAY |
XXX |
DATE |
|
INV_DESTINATION |
XXX |
VARCHAR2 |
1 |
INV_DISCOUNT |
XXX |
VARCHAR2 |
4 |
INV_DISCOUNT_DAYS |
XXX |
VARCHAR2 |
2 |
INV_ENTERED_BY |
XXX |
VARCHAR2 |
4 |
INV_ENTERED_DATE |
XXX |
DATE |
|
INV_FASTCHECK |
XXX |
VARCHAR2 |
1 |
INV_FOREIGN_ADDRESS |
XXX |
VARCHAR2 |
1 |
INV_FREIGHT_INVOICE |
XXX |
VARCHAR2 |
1 |
INV_FRT_AMOUNT |
XXX |
NUMBER |
11,2 |
INV_GROSS_AMOUNT |
XXX |
NUMBER |
11,2 |
INV_LINE_ITEM |
XXX |
VARCHAR2 |
1 |
INV_MAT_REC_DATE |
XXX |
DATE |
|
INV_NET_AMOUNT |
XXX |
NUMBER |
11,2 |
INV_NUMBER |
XXX |
VARCHAR2 |
20 |
INV_OLDRECORD |
XXX |
VARCHAR2 |
1 |
INV_PODIGITS |
XXX |
VARCHAR2 |
9 |
INV_POPREFIX |
XXX |
VARCHAR2 |
3 |
INV_REMITTANCE |
XXX |
VARCHAR2 |
2 |
INV_ROOM_NUMBER |
XXX |
VARCHAR2 |
10 |
INV_SEND_TO_NAME |
XXX |
VARCHAR2 |
20 |
INV_SEPERATE_CHECK |
XXX |
VARCHAR2 |
1 |
INV_SEQNUMBER |
XXX |
VARCHAR2 |
7 |
INV_STATUS |
XXX |
VARCHAR2 |
1 |
INV_STATUS_DATE |
XXX |
DATE |
|
INV_TAXCODE |
XXX |
VARCHAR2 |
1 |
INV_TAXID |
XXX |
VARCHAR2 |
9 |
INV_TERMINAL |
XXX |
VARCHAR2 |
4 |
INV_TO_DEPARTMENT |
XXX |
VARCHAR2 |
1 |
INV_TRANSACTION_TIME |
XXX |
VARCHAR2 |
23 |
INV_TRANSACTION_TYPE |
XXX |
VARCHAR2 |
1 |
INV_VENDOR_COMMITTED |
XXX |
VARCHAR2 |
6 |
INV_VENDOR_PAYTO |
XXX |
VARCHAR2 |
6 |
INV_VERIFIED |
XXX |
VARCHAR2 |
1 |
INV_WHERE_SENT |
XXX |
VARCHAR2 |
5 |