PRD Script run 5.22.19 INSERT INTO PS_ASB_EXP_STG_CS
(BUSINESS_UNIT_GL,
JOURNAL_ID,
JOURNAL_DATE,
UNPOST_SEQ,
JOURNAL_LINE,
LEDGER,
ASB_STG_REC_KEY,
ASB_UNIQUE_REC_KEY,
JRNL_HDR_STATUS,
POSTED_DATE,
FISCAL_YEAR,
ACCOUNTING_PERIOD,
SYSTEM_SOURCE,
DESCR254,
JRNL_LINE_SOURCE,
JRNL_LN_REF,
LINE_DESCR,
ACCOUNT,
ACCOUNT_DESCR,
ACCOUNT_TYPE,
ASB_CN_ADJUST_ID,
DEPTID,
DEPT_DESCR,
OPER_UNIT_DESCR,
OPERATING_UNIT,
PRODUCT,
FUND_CODE,
CLASS_FLD,
PROGRAM_CODE,
BUDGET_REF,
AFFILIATE,
AFFILIATE_INTRA1,
AFFILIATE_INTRA2,
CHARTFIELD1,
CHARTFIELD2,
CHARTFIELD3,
BUSINESS_UNIT_PC,
PROJECT_ID,
ACTIVITY_ID,
RESOURCE_TYPE,
RESOURCE_CATEGORY,
RESOURCE_SUB_CAT,
ANALYSIS_TYPE,
SOURCE_BUS_UNIT,
ASB_OM_BU_DESCR,
BUSINESS_UNIT_OM,
ORDER_NO,
ORDER_INT_LINE_NO,
SCHED_LINE_NBR,
DEBIT_CREDIT,
CURRENCY_CD,
UNIT_OF_MEASURE,
UNIT_MEASURE_STD,
CM_UNIT_COST,
QTY_BASE,
MONETARY_AMOUNT,
ASB_EXTENDED_AMT,
INV_ITEM_GROUP,
ITM_SETID,
BUSINESS_UNIT_IN,
INV_ITEM_ID,
DT_TIMESTAMP,
SEQ_NBR,
INV_LOT_ID,
DEMAND_LINE_NO,
TRANSACTION_GROUP,
ACCOUNTING_DT,
ACCTG_LINE_NO,
COST_ELEMENT,
ASB_CE_DESCR,
CM_BOOK,
CM_DT_TIMESTAMP,
CM_SEQ_NBR,
CM_DT_TIMESTAMP_A,
CM_SEQ_NBR_A,
CM_SEQ_COST,
CM_CST_NSSHIPB,
BUSINESS_UNIT_PO,
PO_ID,
LINE_NBR,
SCHED_NBR,
PO_DIST_LINE_NUM,
BUSINESS_UNIT_AP,
VOUCHER_ID,
VOUCHER_LINE_NUM,
DISTRIB_LINE_NUM,
ASB_VCH_LINE_SEQNO,
APPL_JRNL_ID,
POSTING_PROCESS,
PYMNT_CNT,
DST_ACCT_TYPE,
CF_BAL_LINE_NUM,
ASB_VCH_ACLN_DESCR,
VENDOR_SETID,
VENDOR_ID,
VENDOR_NAME1,
QTY_VCHR,
QTY_VCHR_STD,
MERCH_AMT_BSE,
FREIGHT_AMT_BSE,
MISC_AMT_BSE,
BUSINESS_UNIT_AR,
CUST_ID, ITEM,
ITEM_LINE,
POST_DT,
ENTRY_TYPE,
ENTRY_TYPE_DESCR,
ITEM_STATUS,
ORIG_ITEM_AMT,
FC_AMT,
PAYMENT_METHOD,
DOUBTFUL,
ITEM_SEQ_NUM,
DST_SEQ_NUM,
ENTRY_AMT_BASE,
BUSINESS_UNIT_BI,
INVOICE,
LINE_SEQ_NUM,
INVOICE_TYPE,
INVOICE_DT,
ORDER_DATE,
INVOICE_LINE,
ASB_BI_LN_DESCR,
IDENTIFIER,
PRODUCT_ID,
PROD_CATEGORY,
PRODUCT_DESCR,
PROD_FIELD_C30_A,
PHYSICAL_NATURE,
BILL_TYPE_ID,
BILL_BY_ID,
BILL_SOURCE_ID,
BILL_TO_CUST_ID,
CUST_NAME,
SOLD_TO_CUST_ID,
SHIP_TO_CUST_ID,
SHIP_TO_ADDR_NUM,
ASB_CUST_GROUP_CNO,
ASB_CUST_GROUP_CN,
ASB_CUST_GROUP_ACC,
ASB_PROD_GRP_CNO,
ASB_PROD_GRP_CN,
ASB_PROD_GRP_ACCT,
ASB_PROD_GRP_ACCTP,
ASB_PROD_GRP_RPT,
ASB_STAGED_INVOICE,
ASB_PAYROLL_SYSTEM,
ASB_FILE_TYPE,
ASB_EARNINGS_GROUP,
ASB_CREDIT_TYPE,
ASB_EXT_SYS_CD_VAL,
ASB_CRED_TYP_DESCR,
ASB_PAY_RELEASED,
ASB_PAY_RELEASE_DT,
ASB_INTFC_ID,
STAGE_NBR,
ASB_STAGED_PI,
ASB_STAGED_BY,
ASB_STAGED_DATE,
ASB_STAGED_TIME,
ASB_TRANSMIT_ELIG,
ASB_OK_TO_TRANSMIT,
ASB_TRANSMITTED,
ASB_TRANSMIT_DATE,
ASB_TRANSMIT_PI,
ASB_XC_INCENT_FNAM,
ASB_XC_INCENT_DATE,
ASB_TRANSMIT_COMM)
VALUES('10000', 'IN01125917', '2019-02-04', 0, 12, 'ACTUALS',
'20190204-IN01125917-12-01098-0000025357-8-1-000000000000598682-2019020412011204-180577900000296-01098_L00009354-1-1536149-100-2018123111362014-1-INV03971992-11',
'CS-GIN-20190204-01098-000TL', 'P', '2019-02-04', 2019, 8, 'GIN', 'Inventory Transactions', 'GIN', 'INV', 'Inventory Transactions', '500000', 'Cost of Goods Sold - Product', 'E', 0,
'01098', 'Patrick Kraus/John Letzelter', '', '', '100000', '', '', '', '', '', '', '', '11000', '0000025357', '', '', '', '', '', '', '', '', '01098', 'Patrick Kraus/John Letzelter',
'01098', '0000025357', 8, 1, 'DR', 'USD', 'EA', 'EA', 4.364, 1, 4.36, -4.36, '100000', 'SHARE', 'DNJL', '000000000000598682', '2019-02-04 12:01:12', 180577900000295, '01098_L00009354',
1, '030', '2019-02-04', 1536149, '100', 'Material - General', 'FIN01', '2019-01-30 02:24:13', 1, '2019-01-30 02:24:13', 1, 1, 'N', '', '', 0, 0, 0, '', '', 0, 0, 0, 'INVTRANS', '', 0, '', 0,
'', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, '1900-01-01', '', '', '', 0, 0, '', '', 0, 0, 0, '10000', 'INV03971992', 11, 'REG', '2019-02-15', '2019-01-16', 8, 'PD-Bus Card Takeaways 500/BX',
'000000000000625405', '000000000000625405', '12550', 'PD-Bus Card Takeaways 500/BX', 'M-PRM-1075-01-K', 'G', 'SRB', 'OM_ORDER', 'OM', 'ASB000000447157', 'Square Inc.', 'ASB000000447157', 'ASB000000447157',
8631, 'ADJP', '', '11000', '', '', 'CUSTOM', 'CUSTOM', '', 'Y', 'X', 'CS', 'COGS', 'COGS', 'COGS', 'Cost', 'N', '1900-01-01', 'XACT_EXTRACT_CS', 1, 22810886, 'PSSCHED', '2019-02-05', '12:14:31',
'Y', 'N', 'N', Null, 0, '', '1900-01-01', 'BS-469 - Inserting cost row for insufficient qty error - adj for 1 released on two orders - no CM_ACCTG_LINE for this order') |