Previous | Next | Contents | Index | Navigation | Glossary | Library |
Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
---|---|---|---|
ATTRIBUTE1 to ATTRIBUTE15 | |||
ATTRIBUTE_CATEGORY | |||
BATCH_DATE | |||
BATCH_ID | No | ||
BATCH_SOURCE_ID | NO PARAMETER | ||
COMMENTS | |||
CONTROL_AMOUNT | |||
CONTROL_COUNT | |||
CREATED_BY | No | ||
CREATION_DATE | No | ||
CURRENCY_CODE | Entity: CURRENCY Parameter: CURRENCY_ NAME | NO PARAMETER | |
EXCHANGE_DATE | |||
EXCHANGE_RATE | EXCHANGE_DATE, TRX_DATE, EXCHANGE_RATE_TYPE, CURRENCY_CODE | ||
EXCHANGE _RATE_TYPE | |||
GL_DATE | TRX_DATE | ||
LAST_UPDATED_BY | No | ||
LAST_UPDATE_DATE | No | ||
LAST_UPDATE_LOGIN | No | ||
NAME | |||
ORG_ID | No | ||
PROGRAM_ APPLICATION_ID | No | ||
PROGRAM_ID | No | ||
PROGRAM_UPDATE _DATE | No | ||
PURGED_CHILDREN _FLAG | |||
REQUEST_ID | No | ||
SET_OF_BOOKS_ID | No | ||
STATUS | BATCH_STATUS | NO PARAMETER | |
TYPE | No | Entity: TYPE Parameter: CUST_TRX_ TYPE_NAME | |
Table 1 - 28. (Table 2 of 2) |
Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
---|---|---|---|
AGREEMENT_ID | Entity: AGREEMENT Parameter: AGREEMENT _NAME | INITIAL_CUSTOMER _TRX_ID | |
ATTRIBUTE1 to ATTRIBUTE15 | |||
ATTRIBUTE_CATEGORY | |||
BATCH_ID | Entity: BATCH Parameter: BATCH_NAME | ||
BATCH_SOURCE_ID | Entity: BATCH_SOURCE Parameter: BATCH_ SOURCE_ NAME | BATCH_ID | |
BILL_TO_CONTACT_ID | Entity: CONTACT Parameters: CUSTOMER_ID, FIRST_NAME, LAST_NAME | ||
BILL_TO_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | ||
If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
BILL_TO_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | BILL_TO_CUSTOMER_ID, PREVIOUS_CUSTOMER_ TRX_ID | |
COMMENTS | |||
COMPLETE_FLAG | No | ||
CREATED_BY | No | ||
CREATED_FROM | No | ||
CREATION_DATE | No | ||
CREDIT_METHOD_FOR_ INSTALLMENTS | Entity: CREDIT_METHOD_ FOR_INSTALLMENTS Parameter: CR_METHOD_ FOR_ INSTALLMENT_ NAME | ||
CREDIT_METHOD_FOR_ RULES | Entity: CREDIT_METHOD_ FOR _RULES Parameter: CREDIT_ METHOD_FOR _RULES_ NAME | ||
CUSTOMER_BANK_ ACCOUNT_ID | If you know the bank account name... Entity: BANK_ACCOUNT_ NAME Parameters: BANK_ ACCOUNT_NAME, BANK_BRANCH_ID | TRX_DATE, CURRENCY _CODE, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID | |
If you know the bank account number... Entity: BANK_ACCOUNT_ NUM Parameter: BANK_ ACCOUNT_NUM, BANK_BRANCH_ID | |||
If you know the bank branch name... Entity: BANK_BRANCH Parameters: BANK_NAME, BANK_BRANCH_NAME | |||
CUSTOMER_REFERENCE | |||
CUSTOMER_REFERENCE_DATE | |||
CUSTOMER_TRX_ID | No | ||
CUST_TRX_TYPE_ID | INITIAL_CUSTOMER _TRX_ID, BATCH_ID, BATCH_SOURCE_ID, TRX_DATE, CLASS, INVOICING_RULE_ID, TRX_DATE, BATCH_ID | ||
DEFAULT_TAX_EXEMPT_FLAG | CLASS | ||
DEFAULT_USSGL_ TRANSACTION_CODE | |||
DEFAULT_USSGL_TRX_ CODE_CONTEXT | |||
DOC_SEQUENCE_ID | Entity: DOC_SEQUENCE Parameter: DOC_ SEQUENCE_NAME | ||
DOC_SEQUENCE_VALUE | |||
EDI_PROCESSED_FLAG | |||
EDI_PROCESSED_STATUS | |||
END_DATE_ COMMITMENT | |||
EXCHANGE_DATE | |||
EXCHANGE_RATE | BATCH_EXCHANGE_ RATE, EXCHANGE_DATE, TRX_DATE, EXCHANGE_TYPE, CURRENCY_CODE | ||
EXCHANGE_RATE_TYPE | Entity: EXCHANGE_RATE_ TYPE Parameter: USER_ CONVERSION_TYPE | ||
FINANCE_CHARGES | |||
FOB_POINT | Entity: FOB Parameter: FOB_POINT_ NAME | ||
GLOBAL_ATTRIBUTE1 to GLOBAL_ATTRIBUTE20 | |||
GLOBAL_ATTRIBUTE_ CATEGORY | |||
INITIAL_CUSTOMER_TRX_ID | |||
INTERFACE_HEADER_ ATTRIBUTE1 to INTERFACE_HEADER_ ATTRIBUTE15 | |||
INTERFACE_HEADER_ CONTEXT | |||
INTERNAL_NOTES | |||
INVOICE_CURRENCY_ CODE | NO PARAMETER | ||
INVOICING_RULE_ID | Entity: INVOICING_RULE Parameter: UOM_NAME | ||
LAST_PRINTED_ SEQUENCE_NUM | No | ||
LAST_UPDATED_BY | No | ||
LAST_UPDATE_DATE | No | ||
LAST_UPDATE_LOGIN | No | ||
ORG_ID | No | ||
ORIG_SYSTEM_BATCH_ NAME | |||
PAYING_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | BILL_TO_CUSTOMER_ID | |
If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
PAYING_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | BILL_TO_SITE_USE_ID | |
POSTING_CONTROL_ID | No | ||
POST_REQUEST_ID | No | ||
PREVIOUS_CUSTOMER_ TRX_ID | |||
PRIMARY_SALESREP_ID | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | PREVIOUS_CUSTOMER_ TRX_ID, TRX_DATE, BILL_TO_CUSTOMER_ID | |
If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
PRINTING_COUNT | No | ||
PRINTING_LAST_ PRINTED | No | ||
PRINTING_OPTION | BATCH_SOURCE_ID, CUST_TRX_TYPE_ID | ||
PRINTING_ORIGINAL_ DATE | No | ||
PRINTING_PENDING | |||
PROGRAM_ APPLICATION_ID | No | ||
PROGRAM_ID | No | ||
PROGRAM_UPDATE_ DATE | No | ||
PURCHASE_ORDER | |||
PURCHASE_ORDER_ DATE | |||
PURCHASE_ORDER_ REVISION | |||
RA_POST_LOOP_ NUMBER | No | ||
REASON_CODE | If you know the credit memo reason... Entity: CM_REASON Parameter: CM_REASON_ NAME | ||
If you know the invoice reason... Entity: INVOICE_REASON Parameter: INVOICE_ REASON_NAME | |||
RECEIPT_METHOD_ID | Entity: RECEIPT_METHOD Parameter: RECEIPT_ METHOD_NAME | TRX_DATE, CURRENCY_CODE, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID | |
RECURRED_FROM_TRX_NUMBER | |||
RELATED_BATCH_ SOURCE_ID | |||
REMIT_TO_ADDRESS_ID | BILL_TO_SITE_USE_ID | ||
REQUEST_ID | No | ||
SET_OF_BOOKS_ID | No | ||
SHIPMENT_ID | |||
SHIP_DATE_ACTUAL | |||
SHIP_TO_CONTACT_ID | Entity: CONTACT Parameters: CUSTOMER_ID, FIRST_NAME, LAST_NAME | ||
SHIP_TO_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | ||
If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
SHIP_TO_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | SHIP_TO_CUSTOMER_ID, PREVIOUS_CUSTOMER _TRX _ID | |
SHIP_VIA | Entity: SHIP_VIA Parameter: SHIP_VIA_NAME | ||
SOLD_TO_CONTACT_ID | Entity: CONTACT Parameters: CUSTOMER_ID, FIRST_NAME, LAST_NAME | ||
SOLD_TO_CUSTOMER_ID | If you know the customer name... Entity: CUSTOMER_NAME Parameter: CUSTOMER_ NAME | BILL_TO_CUSTOMER_ID | |
If you know the customer number... Entity: CUSTOMER_NUM Parameter: CUSTOMER_ NUMBER | |||
SOLD_TO_SITE_USE_ID | Entity: SITE_USE Parameters: CUSTOMER_ID, SITE_USE_CODE, ADDRESS1-4, CITY, STATE, PROVINCE, POSTAL_CODE, COUNTY, COUNTRY | BILL_TO_SITE_USE_ID | |
START_DATE_ COMMITMENT | |||
STATUS_TRX | Entity: STATUS_TRX Parameter: STATUS_TRX_ NAME | BATCH_SOURCE_ID, CUST_TRX_TYPE_ID | |
TERM_DUE_DATE | |||
TERM_ID | Entity: TERM Parameter: TERM_NAME | BATCH_SOURCE_ID, CUST_TRX_TYPE_ID | |
TERRITORY_ID | Entity: TERRITORY_ID Parameters: TERR_ SEGMENT1-TERR_ SEGMENT20 | ||
TRX_NUMBER | |||
WAYBILL_NUMBER | |||
WH_UPDATE_DATE | |||
Table 1 - 29. (Table 7 of 7) |
Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
---|---|---|---|
ACCOUNTING_RULE_ DURATION | ACCOUNTING_RULE_ID | ||
ACCOUNTING_RULE_ID | Entity: ACCOUNTING_ RULE Parameter: ACCOUNTING_ RULE_NAME | INVENTORY_ITEM_ID, MEMO_LINE_ID | |
ATTRIBUTE1 to ATTRIBUTE15 | |||
ATTRIBUTE_CATEGORY | |||
AUTORULE_COMPLETE_FLAG | No | ||
AUTORULE_DURATION_PROCESSED | No | ||
AUTOTAX | No | ||
CREATED_BY | No | ||
CREATION_DATE | No | ||
CUSTOMER_TRX_ID | No | ||
CUSTOMER_TRX_LINE_ID | No | ||
DEFAULT_USSGL_ TRANSACTION_CODE | |||
DEFAULT_USSGL_TRX_ CODE_CONTEXT | |||
DESCRIPTION | INVENTORY_ITEM_ID, MEMO_LINE_ID | ||
EXTENDED_AMOUNT | |||
GLOBAL_ATTRIBUTE1 - GLOBAL_ATTRIBUTE20 | |||
GLOBAL_ATTRIBUTE _CATEGORY | |||
INITIAL_CUSTOMER_TRX_LINE_ID | |||
INTERFACE_LINE_ ATTRIBUTE1 - INTERFACE_LINE_ ATTRIBUTE15 | |||
INTERFACE_LINE_ CONTEXT | |||
INVENTORY_ITEM_ID | Entity: INVENTORY_ITEM _ ID Parameters: ITEM_SEGMENT1 - ITEM_SEGMENT30 | ||
ITEM_CONTEXT | |||
ITEM_EXCEPTION_RATE_ID | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
LAST_PERIOD_TO_ CREDIT | |||
LAST_UPDATED_BY | No | ||
LAST_UPDATE_DATE | No | ||
LAST_UPDATE_LOGIN | No | ||
LINE_NUMBER | |||
LINE_TYPE | |||
LINK_TO_CUST_TRX_ LINE_ID | No | ||
LOCATION_SEGMENT_ID | PREVIOUS_CUSTOMER_ TRX _LINE_ID | ||
MEMO_LINE_ID | Entity: MEMO_LINE Parameter: MEMO_LINE_ NAME | ||
MOVEMENT_ID | No | ||
ORG_ID | No | ||
PREVIOUS_CUSTOMER_ TRX_ID | |||
PREVIOUS_CUSTOMER_ TRX_LINE_ID | |||
PROGRAM_ APPLICATION_ID | No | ||
PROGRAM_ID | No | ||
PROGRAM_UPDATE_ DATE | No | ||
QUANTITY_CREDITED | |||
QUANTITY_INVOICED | |||
QUANTITY_ORDERED | |||
REASON_CODE | |||
REQUEST_ID | No | ||
REVENUE_AMOUNT | |||
RULE_START_DATE | ACCOUNTING_RULE_ID, INVOICING_RULE_ID, TRX_DATE | ||
SALES_ORDER | |||
SALES_ORDER_DATE | |||
SALES_ORDER_LINE | |||
SALES_ORDER_REVISION | |||
SALES_ORDER_SOURCE | |||
SALES_TAX_ID | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
SET_OF_BOOKS_ID | No | ||
TAXABLE_FLAG | |||
TAX_EXEMPTION_ID | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
TAX_EXEMPT_FLAG | CLASS | ||
TAX_EXEMPT_NUMBER | |||
TAX_EXEMPT_REASON_ CODE | Entity: TAX_REASON Parameter: TAX_EXEMPT_ REASON_CODE _NAME | ||
TAX_PRECEDENCE | |||
TAX_RATE | PREVIOUS_CUSTOMER_ TRX_ LINE_ID | ||
TAX_VENDOR_RETURN_CODE | |||
UNIT_SELLING_PRICE | CLASS, LINE_TYPE, MEMO_LINE_ID, EXCHANGE_RATE | ||
UNIT_STANDARD_PRICE | CLASS, LINE_TYPE, MEMO_LINE_ID, EXCHANGE_RATE | ||
UOM_CODE | Entity: UOM Parameter: UNIT_OF_ MEASURE | INVENTORY_ITEM_ID, MEMO_LINE_ID | |
VAT_TAX_ID | Entity: TAX_CODE Parameters: TAX_CODE, TRX_DATE | PREVIOUS_CUSTOMER_ TRX _LINE_ID | |
WH_UPDATE_DATE | |||
Table 1 - 31. (Table 3 of 3) |
Column Name | Specify Value? | Available ID Conversion | Default |
---|---|---|---|
ACCOUNT_CLASS | |||
ACCOUNT_SET_FLAG | |||
ACCTD_AMOUNT | |||
AMOUNT | |||
ATTRIBUTE1 to ATTRIBUTE15 | |||
ATTRIBUTE_CATEGORY | |||
CODE_COMBINATION_ID | Entity: CODE_ COMBINATION_ID Parameters: SEGMENT1 - SEGMENT30 | ||
COMMENTS | |||
CONCATENATED_ SEGMENTS | No | ||
CREATED_BY | No | ||
CREATION_DATE | No | ||
CUSTOMER_TRX_ID | No | ||
CUSTOMER_TRX_LINE_ID | No | ||
CUST_TRX_LINE_GL_DIST_ID | No | ||
CUST_TRX_LINE_ SALESREP_ID | No | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | |
If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
GL_DATE | BATCH_GL_DATE, TRX_DATE, COMMITMENT_ GL_DATE, PREV_TRX_GL_DATE, INVOICING_RULE_ID | ||
GL_POSTED_DATE | No | ||
LAST_UPDATED_BY | No | ||
LAST_UPDATE_DATE | No | ||
LAST_UPDATE_LOGIN | No | ||
LATEST_REC_FLAG | |||
ORG_ID | No | ||
ORIGINAL_GL_DATE | |||
PERCENT | |||
POSTING_CONTROL_ID | No | ||
POST_REQUEST_ID | No | ||
PROGRAM_ APPLICATION_ID | No | ||
PROGRAM_ID | No | ||
PROGRAM_UPDATE_ DATE | No | ||
RA_POST_LOOP_ NUMBER | No | ||
REQUEST_ID | No | ||
SET_OF_BOOKS_ID | No | NO PARAMETER | |
USSGL_TRANSACTION_ CODE | Entity: USSGL Parameter: USSGL_TRX_ CODE_NAME | ||
USSGL_TRANSACTION_ CODE_CONTEXT | |||
Table 1 - 32. (Table 2 of 2) |
Column Name | Specify Value? | Available ID Conversion | Default Parameter(s) |
---|---|---|---|
ATTRIBUTE1 to ATTRIBUTE15 | |||
ATTRIBUTE_CATEGORY | |||
CREATED_BY | No | ||
CREATION_DATE | No | ||
CUSTOMER_TRX_ID | No | ||
CUSTOMER_TRX_LINE_ID | No | ||
CUST_TRX_LINE_ SALESREP_ID | No | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | |
If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
LAST_UPDATED_BY | No | ||
LAST_UPDATE_DATE | No | ||
LAST_UPDATE_LOGIN | No | ||
NON_REVENUE_ AMOUNT_SPLIT | |||
NON_REVENUE_ PERCENT_SPLIT | |||
ORG_ID | No | ||
ORIGINAL_LINE_ SALESREP_ID | No | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | |
If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
PREV_CUST_TRX_LINE_ SALESREP_ID | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | ||
If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
PROGRAM_ APPLICATION_ID | No | ||
PROGRAM_ID | No | ||
PROGRAM_UPDATE_ DATE | No | ||
REQUEST_ID | No | ||
REVENUE_AMOUNT_ SPLIT | |||
REVENUE_PERCENT_ SPLIT | |||
SALESREP_ID | If you know the salesperson name... Entity: SALESREP_NAME Parameter: SALESREP_ NAME | ||
If you know the salesperson number... Entity: SALESREP_NUMBER Parameter: SALESREP_ NUMBER | |||
WH_UPDATE_DATE | |||
Table 1 - 33. (Table 3 of 3) |
Previous | Next | Contents | Index | Navigation | Glossary | Library |